<?php defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

/* JoomLeague League Management and Prediction Game for Joomla!
 * Copyright (C) 2007  Robert Moss
 *  
 * Homepage: http://www.joomleague.de
 * Support: htt://www.joomleague.de/forum/
 * 
 * This file is part of JoomLeague.
 *  
 * JoomLeague is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 *
 * Please note that the GPL states that any headers in files and
 * Copyright notices as well as credits in headers, source files
 * and output (screens, prints, etc.) can not be removed.
 * You can extend them with your own credits, though...
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 * The "GNU General Public License" (GPL) is available at
 * http://www.gnu.org/copyleft/gpl.html.
*/ 

class Round extends JLClass{
  // removed round_date and introduced round_date_first, round_date_last
  // Gucky 2007/05/25
  var $id;
  var $matchcode;
  var $name;
  var $round_date_first;
  var $round_date_last;
  var $project_id;
  var $checked_out;
  var $checked_out_time;
  
  function Round( &$db ) {
		$this->mosDBTable( '#__joomleague_rounds', 'id', $db );
	}
  
  function deleteRound($cid = null){
    
  	if (!is_array( $cid ) || count( $cid ) < 1) {
		$this->_error = "No items selected.";
		return false;
	}
	$temperror = true;
    foreach($cid as $cids) {

	    $query = sprintf("SELECT count(match_id) FROM #__joomleague_matches WHERE round_id = %s",intval($cids));
	    $this->_db->setQuery($query);
		$count = $this->_db->loadResult();
	    if( $count == 0 ) {
	      $query = sprintf("DELETE FROM #__joomleague_matches WHERE round_id = %s",$cids);
    	  $this->_db->setQuery($query);
		  $this->_db->query();
		  $this->delete($cids);
		} else $temperror = false;
	}
	
	return $temperror;
  }
  
  /**
   * returns array of the match id of the rounds
   * @return int array
   */        
  function getMatches () {
    $query = "SELECT match_id FROM #__joomleague_matches WHERE round_id = $this->id";
	  $this->_db->setQuery($query);
		return $this->_db->loadResultArray();
  }

  
}

?>
